package com.ruoyi.tb.lmt.service;

import cn.hutool.json.JSONArray;
import cn.hutool.json.JSONObject;
import com.fasterxml.jackson.core.JsonProcessingException;
import com.ruoyi.common.core.domain.PageQuery;
import com.ruoyi.common.core.page.TableDataInfo;
import com.ruoyi.tb.lmt.domain.vo.DrDamperDataVo;
import com.ruoyi.tb.lmt.domain.vo.OilSampleDetectionVo;

import java.io.FileNotFoundException;
import java.util.List;

public interface ISytDataService {
    JSONArray readExcel() throws FileNotFoundException;

    JSONObject readExcelById(String id) throws FileNotFoundException;

    List<DrDamperDataVo> readDamperByDrCarNo(String drCarNo);

    JSONArray execSytJob() throws FileNotFoundException, JsonProcessingException;

    List<OilSampleDetectionVo> getOilSampleData(String oilId,String startDate,String endDate,String oilType);

    TableDataInfo<OilSampleDetectionVo> selectOil(String lmtNumber, String oilType, PageQuery pageQuery);

    TableDataInfo<DrDamperDataVo> selectDamperData(String drDamperNo, String drDamperType, String drCarNo, PageQuery pageQuery);

    OilSampleDetectionVo selectOilById(Long id);

    DrDamperDataVo selectDamperDataById(Long id);

    void  insertMcgs0000(JSONArray lines);

    void insertMcgs0001(JSONArray lines);

    void insertMcgs0002(JSONArray lines);

    void insertMcgs0003(JSONArray lines);

    void insertMcgs0004(JSONArray lines);

    void insertMcgs0005(JSONArray lines);

    void insertMcgs0006(JSONArray lines);

    void insertMcgs0007(JSONArray lines);

    void insertMcgs0008(JSONArray lines);

    void insertMcgs0009(JSONArray lines);

    void insertMcgs0010(JSONArray lines);

    void insertMcgs0011(JSONArray lines);

    void insertMcgs0012(JSONArray lines);

    void insertMcgs0013(JSONArray lines);

    void insertMcgs0014(JSONArray lines);

    void insertMcgs0015(JSONArray lines);

    void insertDrDamperData(JSONArray lines);

    TableDataInfo<OilSampleDetectionVo> selectOilTable(String lmtNumber, String oilType, PageQuery pageQuery);

    OilSampleDetectionVo selectOilDate(String lmtNumber, String oilType, String oilData);
}
